/*    */ package com.yc.dao.export;
/*    */ 
/*    */ import btsm.bean.dbConnector;
/*    */ import com.yc.dao.model.GeographicalenvBo;
/*    */ import com.yc.util.FormateSQL;
/*    */ import java.sql.ResultSet;
/*    */ import java.util.ArrayList;
/*    */ import java.util.List;
/*    */ import org.apache.commons.logging.Log;
/*    */ import org.apache.commons.logging.LogFactory;
/*    */ 
/*    */ public class EnvDAO
/*    */   implements IExportAll
/*    */ {
/* 19 */   private static final Log log = LogFactory.getLog(EnvDAO.class);
/*    */ 
/*    */   public List export(dbConnector dbcon, String strBtsName, String strRegistBeginTime, String strRegistEndTime)
/*    */   {
/* 23 */     ResultSet rs = null;
/* 24 */     List list = new ArrayList();
/*    */     try
/*    */     {
/* 27 */       String strSQL = " select * from geographicalenv where btsname like '%" + strBtsName + "%' ";
/* 28 */       strSQL = FormateSQL.getFormateSQL(strRegistBeginTime, strRegistEndTime, strSQL);
/* 29 */       log.info(strSQL);
/* 30 */       rs = dbcon.execQuery(strSQL);
/* 31 */       int i = 0;
/* 32 */       while (rs.next()) {
/* 33 */         GeographicalenvBo bo = new GeographicalenvBo();
/* 34 */         bo.setId(String.valueOf(i++));
/* 35 */         bo.setBtscode(rs.getString("btscode"));
/* 36 */         bo.setBtsname(rs.getString("btsname"));
/* 37 */         bo.setBtszone(rs.getString("btszone"));
/* 38 */         bo.setLandform(rs.getString("landform"));
/* 39 */         bo.setLng(rs.getString("lng"));
/* 40 */         bo.setLat(rs.getString("lat"));
/* 41 */         bo.setRelocationrd(rs.getString("relocationrd"));
/* 42 */         bo.setUsername(rs.getString("username"));
/* 43 */         bo.setDistcode(rs.getString("distcode"));
/* 44 */         bo.setBtslevel(rs.getString("btslevel"));
/* 45 */         bo.setWorkingradius(rs.getString("workingradius"));
/* 46 */         bo.setRefreshtime(rs.getDate("refreshtime"));
/* 47 */         bo.setMemo(rs.getString("memo"));
/* 48 */         bo.setGraphDeatilAddr(rs.getString("graphDeatilAddr"));
/* 49 */         bo.setGraphHigh(rs.getString("graphHigh"));
/*    */ 
/* 51 */         bo.setTrannetid(rs.getString("trannetid"));
/* 52 */         bo.setTrannetname(rs.getString("trannetname"));
/* 53 */         bo.setTrannetgrade(rs.getString("trannetgrade"));
/* 54 */         bo.setRegisttime(rs.getDate("registtime"));
/* 55 */         bo.setBtskind(rs.getString("btskind"));
/* 56 */         bo.setBtstype(rs.getString("btstype"));
/* 57 */         bo.setCoverage(rs.getString("coverage"));
/* 58 */         bo.setMaintype(rs.getString("maintype"));
/*    */ 
/* 61 */         list.add(bo);
/*    */       }
/*    */     }
/*    */     catch (Exception e) {
/* 65 */       e.printStackTrace();
/* 66 */       log.error(e.getMessage());
/*    */     }
/* 68 */     return list;
/*    */   }
/*    */ }

/* Location:           E:\java\apache-tomcat-6.0.36\webapps\btsm\WEB-INF\classes\
 * Qualified Name:     com.yc.dao.export.EnvDAO
 * JD-Core Version:    0.6.2
 */